
create table SYS_API_URL
(
    ID           NUMBER primary key,
    config_name  VARCHAR2(100) not null,
    config_key   VARCHAR2(100) not null,
    config_value VARCHAR2(500) not null,
    sdate        VARCHAR2(100),
    edate        VARCHAR2(100)
);
comment on column SYS_API_URL.id
    is '主键';
comment on column SYS_API_URL.config_name
    is '配置名称';
comment on column SYS_API_URL.config_key
    is '唯一标识';
comment on column SYS_API_URL.config_value
    is '配置值';
comment on column SYS_API_URL.sdate
    is '首次调用时间';
comment on column SYS_API_URL.edate
    is '最后调用时间';

create unique index SYS_API_URL_IDX1 on SYS_API_URL (CONFIG_KEY);

CREATE SEQUENCE   "SYS_API_URL_SEQ"
    MINVALUE 1
    MAXVALUE 9999999999999999999999999999
    INCREMENT BY 1
    START WITH 1
    CACHE 20
    NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL
;

CREATE TRIGGER  "BI_SYS_API_URL"
    before insert on "SYS_API_URL"
    for each row
begin
    if :NEW."ID" is null then
        select "SYS_API_URL_SEQ".nextval into :NEW."ID" from dual;
    end if;
end;
/

INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('资产类别', 'gdzclb', '/assetApi/basic/getzctype');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('资产来源', 'gdzcly', '/assetApi/basic/getzcsources');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('资产状态', 'gdzczt', '/assetApi/basic/getzcztinfo');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('资产用途', 'gdzcyt', '/assetApi/basic/getzcusage');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('资产处置类型', 'gdzcczlx', '/assetApi/basic/getzctreatmenttype');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('资产折旧方法', 'gdzczjff', '/assetApi/basic/getFIGDZjff');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('资产变更类型', 'gdzcbglx', '/assetApi/basic/getFIGDBGLX');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('银行等级', 'banklevel', '/reimburseInterfaceApi/reimburse/getBFBankLevel');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('银行类型', 'banktype', '/reimburseInterfaceApi/reimburse/getBFBankType');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('项目状态', 'projectstate', '/reimburseInterfaceApi/reimburse/getBFPROJECTSTATE');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('项目类型', 'projecttype', '/reimburseInterfaceApi/reimburse/getBFPROJECTTYPE');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('组织机构', 'masterorg', '/BasicdataApi/basic/GetBfmasterorganization');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('发票类型', 'invType', '/expenseInterfaceApi/ea/getInvoiceType');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('业务事项', 'ywsx', '/reimburseInterfaceApi/reimburse/getBFBUSINESSMATTER');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('码表（自定义项目）类型', 'mblx', '/reimburseInterfaceApi/reimburse/getCustomerItemsType');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('码表（自定义项目）值', 'mb', '/reimburseInterfaceApi/reimburse/getCustomerItems');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('合同类型', 'htlx', '/contractApi/basic/getcttypeInfo');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('合同状态', 'htzt', '/contractApi/basic/getctztInfo');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('往来单位类别', 'wldwlb', '/partnerInterfaceApi/partner/getBfPartnerType');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('年初余额', 'ncye', '/BasicdataApi/basic/getAccTitleData');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('预算项目', 'ysxm', '/BasicdataApi/tb/getYsysxm');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('科目体系', 'kmtx', '/cwBaseApi/cwBase/getBfChartOfAccount');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('会计科目', 'km', '/cwBaseApi/cwBase/getBfAccountTitle');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('用户信息', 'user', '/BasicdataApi/basic/GetGspuser');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('行政人员', 'bfemployee', '/BasicdataApi/basic/GetBfemployee');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('合同报销/合同付款业务明细', 'htmx', '/GetPayStatusApi/pay/getJCBusinessDetails');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('行政组织', 'organization', '/BasicdataApi/basic/GetBfadminorganization');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('报账单', 'bzd', '/GXBZDJGetApi/fsbzdj/getFSBZDJ');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('往来单位', 'wldw', '/partnerInterfaceApi/partner/getBfPartner');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('合同台账', 'ht', '/get/ContractParameter/getContractParameter');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('银行定义接口', 'bank', '/reimburseInterfaceApi/reimburse/getBFBank');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('核算项目类别', 'xmlb', '/cwBaseApi/cwBase/getBFCustomItemCategory');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('核算项目', 'xm', '/cwBaseApi/cwBase/getBFCustomItems');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('凭证接口', 'pz', '/voucherInterfaceApi/via/getVoucherList');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('核算部门', 'bm', '/BasicdataApi/basic/GetBfaccountingdepartment');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('核算人员', 'zg', '/BasicdataApi/basic/GetBfaccountingemployee');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('核算账簿', 'hsdw', '/cwBaseApi/cwBase/getBfLedger');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('科目核算关系', 'kmhsgx', '/cwBaseApi/cwBase/getBfAccTitleAccRlat');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('会计期间', 'kjqj', '/cwBaseApi/cwBase/getBfFIAccountcalendar');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('币种', 'currency', '/reimburseInterfaceApi/reimburse/getBFCURRENCY');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('凭证类型', 'pzlx', '/cwBaseApi/cwBase/getFIGLAccDocType');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('项目信息', 'project', '/reimburseInterfaceApi/reimburse/getBFPROJECTINFO');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('款项性质', 'kxxz', '/reimburseInterfaceApi/reimburse/getBFFUNDSPROP');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('结算方式', 'jsfs', '/reimburseInterfaceApi/reimburse/getBFSETTLEMENTWAY');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('银行账户', 'bankaccount', '/reimburseInterfaceApi/reimburse/getBFBankAccounts');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('报账单支付状态', 'djzt', '/GetPayStatusApi/pay/getFSBZDJStatus');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('开支内容', 'kznr', '/reimburseInterfaceApi/reimburse/getBFExpensesType');
INSERT INTO SYS_API_URL (CONFIG_NAME, CONFIG_KEY, CONFIG_VALUE) VALUES ('凭证接口-测试', 'pz-test', '/getVoucherList');
